package com.allwees.bs.module.oms.dao;

import com.allwees.bs.module.oms.entity.OmsOrder;
import com.allwees.core.dao.mybatis.dao.BaseDao;
import org.apache.ibatis.annotations.Select;

import java.util.Date;
import java.util.List;

public interface OmsOrderDao extends BaseDao<OmsOrder> {

    @Select({"<script>",
            "SELECT * FROM oms_order o ",
            "where o.wf_state = 'RECEIVED' AND o.receive_at &lt; #{expireDate}",
            "</script>"
    })
    List<OmsOrder> findExpireToSettleUuids(Date expireDate);
}
